Stored Procedures [dbo].[BAEFieldDesignSectionLookupUpdate]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEFieldDesignSectionLookupUpdate
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@TableNamevarchar(30)30
@FieldNamevarchar(30)30
@FieldSectionIdint4
@SortOrderint4
SQL Script
create procedure [dbo].[BAEFieldDesignSectionLookupUpdate] @TableName as
varchar(30),
    @FieldName AS varchar(30),
    @FieldSectionId AS int,
    @SortOrder AS int
AS
    UPDATE FieldDesignSectionLookup SET
    SortOrder = @SortOrder
    WHERE TableName = @TableName AND
    FieldName = @FieldName AND
    FieldSectionId = @FieldSectionId

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved